SHOW FULL COLUMNS FROM `mtr_bus_route` [ RunTime:0.000569s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-884-O-0' LIMIT 1 [ RunTime:0.000287s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-884-O-0' LIMIT 1 [ RunTime:0.000228s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-884-I-0' LIMIT 1 [ RunTime:0.000253s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-884-I-0' LIMIT 1 [ RunTime:0.000195s ]
SHOW FULL COLUMNS FROM `mtr_bus_stop` [ RunTime:0.000425s ]
SELECT `id`,`name` FROM `mtr_bus_stop` WHERE `id` IN ('RMB-42163','RMB-42167','RMB-42168','RMB-42169','RMB-42173','RMB-42174','RMB-42175','RMB-42176','RMB-42177','RMB-42178','RMB-42179','RMB-42180','RMB-42181','RMB-42182','RMB-42183','RMB-42184') [ RunTime:0.005931s ]
SELECT `id`,`no`,`co`,`name`,`stop_list`,`orig`,`dest` FROM `mtr_bus_route` `r` WHERE `r`.`bound` = 'O' AND ( JSON_CONTAINS(stop_list, '"RMB-42163"') ) LIMIT 10 [ RunTime:0.071345s ]